# coding: utf-8
from application import db


class GameItem(db.Model):
    __tablename__ = 'game_item'

    id = db.Column(db.Integer, primary_key=True, info='ID')
    title = db.Column(db.String(128), nullable=False, info='名称')
    created_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
    updated_time = db.Column(db.DateTime, nullable=False, server_default=db.FetchedValue())
    is_delete = db.Column(db.Integer, nullable=False)
    g_id = db.Column(db.Integer, nullable=False, info='游戏ID')
    gc_id = db.Column(db.Integer, nullable=False, info='类目ID')
    p1 = db.Column(db.String(64), nullable=False, server_default=db.FetchedValue(), info='参数1')
    p2 = db.Column(db.String(64), nullable=False, server_default=db.FetchedValue(), info='参数2')
    p3 = db.Column(db.String(64), nullable=False, server_default=db.FetchedValue(), info='参数3')
    p4 = db.Column(db.String(64), nullable=False, server_default=db.FetchedValue(), info='参数4')
    p5 = db.Column(db.String(64), nullable=False, server_default=db.FetchedValue(), info='参数5')
    p6 = db.Column(db.String(64), nullable=False, server_default=db.FetchedValue(), info='参数6')
    p7 = db.Column(db.String(64), nullable=False, server_default=db.FetchedValue(), info='参数7')
    p8 = db.Column(db.String(64), nullable=False, server_default=db.FetchedValue(), info='参数8')
